package com.imti.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.imti.entity.DrugCharge;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * 收费项目(DrugCharge)表数据库访问层
 *
 * @author makejava
 * @since 2023-02-03 17:46:39
 */
@Mapper
public interface DrugChargeDao extends BaseMapper<DrugCharge> {

    @Select("SELECT item_name,item_type,item_momey,item_status,item_units FROM drug_charge WHERE item_name LIKE concat('%',#{itemName},'%')")
    public List<DrugCharge> findDrugChargeByName(String itemName);
}

